package com.qf.mapper;

import com.qf.pojo.SysDevice;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;

/**
 * created by 赵文韬 on 2022/3/24 11:19
 */
public interface SysDeviceMapper {
    //添加
    @Insert("INSERT INTO sys_device (device_id,device_name,categy_id,bind_user_id,scene_id,bind_time) values (#{deviceId},#{deviceName},#{categyId},#{bindUserId},#{sceneId},#{bindTime})")
    void addDevice(SysDevice sysDevice);
    //查询
    @Select("select * from sys_device where device_id=#{DeviceId}")
    SysDevice findByDeviceId(String DeviceId);
    //更新
    int updateDevice(SysDevice sysDevice);
}
